package com.ruoyi.system.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import com.ruoyi.system.domain.WGood;
import com.ruoyi.system.domain.WGoodsRecords;
import com.ruoyi.system.domain.WOrderGood;
import com.ruoyi.system.domain.vo.WGoodExcel;
import com.ruoyi.system.domain.vo.WGoodVO;

/**
 * 物品Mapper接口
 * 
 * @author ruoyi
 * @date 2021-12-05
 */
public interface WGoodMapper 
{
    /**
     * 查询物品
     * 
     * @param id 物品主键
     * @return 物品
     */
    public WGood selectWGoodById(Long id);

    /**
     * 查询物品列表
     * 
     * @param wGood 物品
     * @return 物品集合
     */
    public List<WGood> selectWGoodList(WGood wGood);
    
    
    public List<WGoodVO> selectWGoodListNew(WGoodVO wGoodVO);
    
    
    public List<WGood> selectWGoodListByPnList(@Param("wGoodExcelList")  List<WGoodExcel> wGoodExcelList, 
    		@Param("customerId")Long customerId,@Param("deptId")Long deptId);
    
    public List<WGood> selectWGoodListByPnListNew(@Param("wGoodExcelList")  List<WOrderGood> wGoodExcelList, 
    		@Param("customerId")Long customerId,@Param("deptId")Long deptId);
    
    
    public int updateWGoodNum(WGoodsRecords wGoodsRecords);
    //完成
    public int updateWGoodComplete(WGoodsRecords wGoodsRecords);

    /**
     * 新增物品
     * 
     * @param wGood 物品
     * @return 结果
     */
    public int insertWGood(WGood wGood);

    /**
     * 修改物品
     * 
     * @param wGood 物品
     * @return 结果
     */
    public int updateWGood(WGood wGood);

    /**
     * 删除物品
     * 
     * @param id 物品主键
     * @return 结果
     */
    public int deleteWGoodById(Long id);

    /**
     * 批量删除物品
     * 
     * @param ids 需要删除的数据主键集合
     * @return 结果
     */
    public int deleteWGoodByIds(Long[] ids);
}
